UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aAZ9v8mPvkYKPZq9nMqR9CQXeoudhLVLKf8A8B9NpLg='
WHERE
key_id = 'd6b63ea034baffe54ece6c9e3e3758d8b7bb02e39d885eeffbe8a188a76c072b'
AND (
token = 'aAZ9v8mPvkYKPZq9nMqR9CQXeoudhLVLKf8A8B9NpLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)