UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CeNdYAi4MnnCsrrA9cvhJmr5tqPIT9ZF1C/K/b4Jy4M='
WHERE
key_id = '4293552d9fbe30110145f894e89339728e7dadd25d89d210082d1b67ec75167d'
AND (
token = 'CeNdYAi4MnnCsrrA9cvhJmr5tqPIT9ZF1C/K/b4Jy4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)