SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2358fdeeb9566c33df4fc6a534816e7e1587574a7dd255722c0c03feb1214dee' 
  AND token = '6+Y4xdT+UB0JXNAm5iW0zJYjyttyc4Mq3617QYgw5Ms=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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