UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sG340fCISQ2huQAqvqFENsGPEmF91WBdvgIZ2nntREQ='
WHERE
key_id = '139fc92d48957451c896a98e709188241adb611f49a2dd6923488b516c20a0b3'
AND (
token = 'sG340fCISQ2huQAqvqFENsGPEmF91WBdvgIZ2nntREQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)