UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thAMPxY2wOEqtgGPbieGOI2vqSPiMH1ip/G6+SU5Yvo='
WHERE
key_id = 'a8a1c7b40b5e082105e6620005c66ebe6d36d5708d130d8f2682cf75132afd68'
AND (
token = 'thAMPxY2wOEqtgGPbieGOI2vqSPiMH1ip/G6+SU5Yvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)