UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDwIwoiSgKeBQbPN6fOInn1lPHTPRedvOzBxKNTSA9M='
WHERE
key_id = '7da9e2c57f7dc87cd89210e19bc87ce0e14a0d890aa501e5a52b4deb5fa75f1e'
AND (
token = 'zDwIwoiSgKeBQbPN6fOInn1lPHTPRedvOzBxKNTSA9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)