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