UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAcvIdkj+c6aSGJpv3SySv6a+qu+Y8y3MJLpejRJ39g='
WHERE
key_id = '5e443845999957d277f0789a9708a617a9ac0b3b2e0c5b300417dc62f7284820'
AND (
token = 'CAcvIdkj+c6aSGJpv3SySv6a+qu+Y8y3MJLpejRJ39g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)