UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ySoDjJgztA0jOJyXBiwYrjTXt2Mf18cpXq9ONEWTmMM='
WHERE
key_id = '178f227350f31bdd34c7155be74e300881a7e662c1a2f5b49efb021149a05029'
AND (
token = 'ySoDjJgztA0jOJyXBiwYrjTXt2Mf18cpXq9ONEWTmMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)