SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '64fa5b220f7bdb8b21e46049993953506cde6d5aaac50d206d2fca97fa1997b7' 
  AND token = 'wiLy4wEJz+S+a+8O8DGlU9S9PWO0i5frtg7JJpqgZF4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}