UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtxCqlBYv64k26OaRqAeySVak42ySmcriEd8cbkZNSM='
WHERE
key_id = '820ced47eb5925e570faa6167a4d6cd80ff56fd95766be643c21c93d130dc157'
AND (
token = 'xtxCqlBYv64k26OaRqAeySVak42ySmcriEd8cbkZNSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)