UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49gGeYSyGMbTwetooDE77+SLLhKgy5MRu6eu+96Y5Og='
WHERE
key_id = '30bcdab256c0924068f6bdbec5e089677036e693e3274e3ce7a872213e1a4550'
AND (
token = '49gGeYSyGMbTwetooDE77+SLLhKgy5MRu6eu+96Y5Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)