UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fC8YATCu9KcRSKT6JUoLwHplpF2PN8FU97aVdE2NKxU='
WHERE
key_id = '7e99391c29b9acb77d0b7917a114194b2d76af3c7ea2782a09fabb4516ff4188'
AND (
token = 'fC8YATCu9KcRSKT6JUoLwHplpF2PN8FU97aVdE2NKxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)