UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ezhj9hX+VSztQDdmn0bDdtnWF1dN56KsXNgFU2W+Qs='
WHERE
key_id = '7cfe7af7b616960f94b311c9257c9c72f1e31cb0bbe07ef8a026baf822ae2398'
AND (
token = '9ezhj9hX+VSztQDdmn0bDdtnWF1dN56KsXNgFU2W+Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)