UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/dgGBESfFFrOZhcTfthgdHPsNzqC9BH0W+x38sMHvI='
WHERE
key_id = 'bb9bbe9f07bdf2f93df9e2263450804ca7b3c5dcc48c867f62dc0d56dab5411f'
AND (
token = 'q/dgGBESfFFrOZhcTfthgdHPsNzqC9BH0W+x38sMHvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)