UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y3x91b1pCLgCIXx7Vk/7+ShZ5OFWNUh2CZUSenjQ1m8='
WHERE
key_id = '487265b2e64efafccddfe050153d334a8c4d7e07cab1d0ee60656d4bffd99609'
AND (
token = 'Y3x91b1pCLgCIXx7Vk/7+ShZ5OFWNUh2CZUSenjQ1m8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)