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