UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xFrl/GFyqKTPFyxYGw2o+OsAGUgfAs6de4lNSft8yYw='
WHERE
key_id = '1ed3ee5a46c044756f3a06b8f3c6268fce2c6956734ae999268cfb4b9da05675'
AND (
token = 'xFrl/GFyqKTPFyxYGw2o+OsAGUgfAs6de4lNSft8yYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)