UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/oJGoOVOm1t4+2CsNXV7ke2JQF5qAI2Z6cZZSTOILc='
WHERE
key_id = 'b970d3c3161891f2989a34123cac80cc8888fec7f2c27fb58088a7146442fb08'
AND (
token = 'A/oJGoOVOm1t4+2CsNXV7ke2JQF5qAI2Z6cZZSTOILc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)