SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'fa49d29d76deca1986db94048903aa1572ab7384bc8d348b84684032e66e8abc' 
  AND token = 'y0zzQc3GQwg0SPT5w5aHHBT/n6VeQVvh9Fa4RbkjaUI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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