UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EG6pBMtq8VIXpXwV+3IQePH5MpQRJVMxj0zAQJI0kQ='
WHERE
key_id = '6effddebf08314757f0862a00e28476a61bff1761740758773a2c3ff746d0e1b'
AND (
token = '0EG6pBMtq8VIXpXwV+3IQePH5MpQRJVMxj0zAQJI0kQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)