UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVJNSD9y2uhgwhHzWwdVcE01zI7Jurzk5JP5eA/oYS8='
WHERE
key_id = 'd652fbc91b38c2378aada5f1b96471646ab73e4cedf3cd4f569c2e9db4ab4345'
AND (
token = 'VVJNSD9y2uhgwhHzWwdVcE01zI7Jurzk5JP5eA/oYS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)