UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bHOKWZVoKBcH4eq9vYRu31jJg5PesY41sQIbgyWduo='
WHERE
key_id = '46867c27530539e2a5fd5996ea2ecdbe4aacbd49bd86dbbb7e39919c23327648'
AND (
token = '3bHOKWZVoKBcH4eq9vYRu31jJg5PesY41sQIbgyWduo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)