UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLNy9K4qD7XSdYP0pvsj0BB5VkQBouuneZTPI1I/p2s='
WHERE
key_id = 'f5cf78baa0edb6b79e581afc5a221aacf5c28509630bb849ac305ceae4484cc5'
AND (
token = 'pLNy9K4qD7XSdYP0pvsj0BB5VkQBouuneZTPI1I/p2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)