UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvfvI4/QFAOkrkj9lk4OSEXV7JliAwx17fEet5m77Q0='
WHERE
key_id = 'bc71c394a048f6b38392591ba5a3fb7d1e3c43637dc0d8b12ae028b56b45cad3'
AND (
token = 'VvfvI4/QFAOkrkj9lk4OSEXV7JliAwx17fEet5m77Q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)