UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBfy6tcJg1L/zcoHa1QLP8Kz8RRadrmy3qLhcBp/8A4='
WHERE
key_id = '42f840f8855005d5c7bf3203c161c74435a25aa8eb95ea24933448b39c66ef8f'
AND (
token = 'LBfy6tcJg1L/zcoHa1QLP8Kz8RRadrmy3qLhcBp/8A4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)