UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0BXUiRgP7tkE2J6+6aGrlIVWUqnruhpVaTgx/ba5D0='
WHERE
key_id = 'a9e319682e91cde44ddc626c7f0f5e03eeebdba97b55a574a123eee264ffd329'
AND (
token = 'Z0BXUiRgP7tkE2J6+6aGrlIVWUqnruhpVaTgx/ba5D0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)