UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TGeboq48A5Mn6yeQF1aOm9l5NSW97C+R1QAbIMKvT+E='
WHERE
key_id = '46ec4e8a454250a8118702936d05e0c7e3a0e15c13bdbe68471739a344fcc556'
AND (
token = 'TGeboq48A5Mn6yeQF1aOm9l5NSW97C+R1QAbIMKvT+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)