UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65i9GuK2NvXai4ltt0IdYpyDeYc8m3YkWEDq4Tctihk='
WHERE
key_id = 'ea74397e586261ce27368ee18f3c96f6156f628cbdaab62fc6f75f65480a139e'
AND (
token = '65i9GuK2NvXai4ltt0IdYpyDeYc8m3YkWEDq4Tctihk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)