UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UzGVtP7Owow/g00a3IopnfbHu3j0YDrpGEZwaRV8EVI=' 
WHERE 
  key_id = '6bd6532e9b6ff99ed0ef8842c9cd3292c6c9c8eca95100097e3e17578fda06f3' 
  AND (
    token = 'UzGVtP7Owow/g00a3IopnfbHu3j0YDrpGEZwaRV8EVI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035