UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KyO6nmF41w4c3i5tWmetLVwy0ymMLUaosrruTSAT0Rs='
WHERE
key_id = 'd20c74ebce824ffc25ecc590235f15ed6fe65a721765cf14feba0fd04639f5dc'
AND (
token = 'KyO6nmF41w4c3i5tWmetLVwy0ymMLUaosrruTSAT0Rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)