UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4Sz8RU/jUCf2V65/eltPEM1ROJv2K6K1Cwyg1tIMGc='
WHERE
key_id = '0cd2a7dfcf5dd30b8b0b3b92ad9c7016218f8a877aea765803bfae5579fa9e0f'
AND (
token = 'N4Sz8RU/jUCf2V65/eltPEM1ROJv2K6K1Cwyg1tIMGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)