UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fBI13vgp2OhVY7WwhrmeZo03rg8g3LtrAOZBSOkTTVQ='
WHERE
key_id = '5bccfbc8d33dc808b1d2a48e057db9d59e8cb175b990e82b5736e003860b5bf8'
AND (
token = 'fBI13vgp2OhVY7WwhrmeZo03rg8g3LtrAOZBSOkTTVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)