SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8f93e76ad578313987b898f63904f12a5745c0a25073d1257d8f5ab7e5168272' 
  AND token = 'W+zNd5+oCum3WaMQQnr1eCr2lA9jGDbGZ3g6x308SX8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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