UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H16I4xhuY2vxWo79v7TiSsHKYu85V9I7KQLW6ZN5bC8='
WHERE
key_id = 'b77fc1318350cf204d25581fb260df4e5039077029e2bf2478e8c8733d6d03f9'
AND (
token = 'H16I4xhuY2vxWo79v7TiSsHKYu85V9I7KQLW6ZN5bC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)