SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '89b9e63f27d5cebb3a7cfc83c66d3d56ea6aada37728042ddd789879d4b6b46e' 
  AND token = 'ZYNBQNAR8l89FMQvhMfdIAs4MaH7JC7Vk5Jf5x8Bk3I=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}