UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfzeHpagfo+1hYg27gBqtmrjwpUoGF8S8qGta1O6ioE='
WHERE
key_id = 'e891dc7ef19a4ce1bf924f717b8a81c0c9d8baab68d6c82253a0c8915ee59297'
AND (
token = 'pfzeHpagfo+1hYg27gBqtmrjwpUoGF8S8qGta1O6ioE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)