UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8ME56RRYTzSYJ0N/BTvm7hARIyB5gjR8PO6bflC2Aw='
WHERE
key_id = 'a7981c06c5929f708f140ca4dcffcde54ad94aca0fd22e75392651312d65d9e6'
AND (
token = 'k8ME56RRYTzSYJ0N/BTvm7hARIyB5gjR8PO6bflC2Aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)