UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9eYyodm+wNePooDnV3AAeIoIFU1Jycl9AfbTCP+HcgU='
WHERE
key_id = '6de0cd2585281abd5e6d75a56951ad5c35525fbe62e77fbca5a0c100cf60a30e'
AND (
token = '9eYyodm+wNePooDnV3AAeIoIFU1Jycl9AfbTCP+HcgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)