UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8IJw3+5cim+X3VzMZ1Z2/3FBkS4vKGFnC/Gb7oMj8s0='
WHERE
key_id = '012f7baf823d8dfe05322291f85e17fdd863cd71af8d3711b6bf484cb1ef8378'
AND (
token = '8IJw3+5cim+X3VzMZ1Z2/3FBkS4vKGFnC/Gb7oMj8s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)