SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5edd82e0b99397a33660da29249ada3a798c27974063c8bd593e2f130de6e381' 
  AND token = 'jGZJIBsgNXl06drh8ppU0bCsn9AXmrgrv0RN6l/GGnk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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