SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3216ca62218e139d5ed4f7445f1b14e6fc193124d75a37a60d5f1a886d1078ac' 
  AND token = 'mJ+xiuskE+XtQ41BlZJVPx3EqARo9gs2iQLmVp6WMbg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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